/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : localhost:3306
 Source Schema         : kwshare-config

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 15/01/2022 18:50:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for config_info
-- ----------------------------
DROP TABLE IF EXISTS `config_info`;
CREATE TABLE `config_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  `c_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `c_schema` text CHARACTER SET utf8 COLLATE utf8_bin,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='config_info';

-- ----------------------------
-- Records of config_info
-- ----------------------------
BEGIN;
INSERT INTO `config_info` VALUES (1, 'kwshare-file-dev.yml', 'DEFAULT_GROUP', '# 文件上传路径\nfile:\n  path: D:\\KwShare\\', '6b75994e5fce0f56ee9f9c76b501e3ac', '2021-12-18 05:03:02', '2021-12-26 07:28:24', 'nacos', '0:0:0:0:0:0:0:1', '', '', '文件服务', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (2, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-auth\n        uri: lb://kwshare-auth\n        predicates:\n          - Path=/auth/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-user\n        uri: lb://kwshare-user\n        predicates:\n          - Path=/user/**\n        filters:\n          - StripPrefix=1\nsecurity: \n  ignore:\n    whites: \n    - /auth/login\n    - /auth/logout', '7f0c634265c16064edc679017baae586', '2021-12-18 05:03:38', '2021-12-30 14:07:35', 'nacos', '0:0:0:0:0:0:0:1', '', '', '网关服务', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (4, 'kwshare-system-dev.yml', 'DEFAULT_GROUP', 'spring:\n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: 12345678\n    url: jdbc:mysql://localhost:3306/kwshare-user?useUnicode=true&characterEncoding=utf8\nmybatis-plus:\n  global-config:\n    db-config:\n      id-type: 0\n  configuration:\n    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl', '04a3b6f33680e656e7d0b744b7676149', '2021-12-18 05:04:46', '2022-01-08 09:19:32', 'nacos', '0:0:0:0:0:0:0:1', '', '', '系统服务', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (14, 'kwshare-monitor-dev.yml', 'DEFAULT_GROUP', '#spring\nspring: \n  security:\n    user:\n      name: yangjing\n      password: 123456\n  boot:\n    admin:\n      ui:\n        title: 知优享服务状态监控', 'b66bbbab30dc701804212a5883389a0b', '2021-12-18 12:01:24', '2021-12-18 12:02:09', 'nacos', '192.168.146.1', '', '', '监控服务', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (15, 'kwshare-user-dev.yml', 'DEFAULT_GROUP', 'spring:\n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: 12345678\n    url: jdbc:mysql://localhost:3306/kwshare-user?useUnicode=true&characterEncoding=utf8\nmybatis-plus:\n  global-config:\n    db-config:\n      id-type: 0\n  configuration:\n    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl', '04a3b6f33680e656e7d0b744b7676149', '2021-12-19 08:23:56', '2021-12-31 15:24:12', 'nacos', '0:0:0:0:0:0:0:1', '', '', '用户服务', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (20, 'kwshare-auth-dev.yml', 'DEFAULT_GROUP', 'a: a', 'a47864918ca9e5733d9f1c22f49afeb6', '2021-12-26 06:36:26', '2021-12-26 07:30:03', 'nacos', '0:0:0:0:0:0:0:1', '', '', '认证服务', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES (23, 'application-dev.yml', 'DEFAULT_GROUP', 'spring:\n  boot:\n    admin:\n      client:\n        url: http://localhost:9100\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n  endpoint:\n    health:\n      show-details: ALWAYS', '61e195a4d0dd1853ca3572f08e0f4a02', '2021-12-26 07:28:35', '2021-12-26 07:28:35', NULL, '0:0:0:0:0:0:0:1', '', '', '公共配置', NULL, NULL, 'yaml', NULL);
COMMIT;

-- ----------------------------
-- Table structure for config_info_aggr
-- ----------------------------
DROP TABLE IF EXISTS `config_info_aggr`;
CREATE TABLE `config_info_aggr` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `datum_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '内容',
  `gmt_modified` datetime NOT NULL COMMENT '修改时间',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='增加租户字段';

-- ----------------------------
-- Records of config_info_aggr
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_info_beta
-- ----------------------------
DROP TABLE IF EXISTS `config_info_beta`;
CREATE TABLE `config_info_beta` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `beta_ips` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'betaIps',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='config_info_beta';

-- ----------------------------
-- Records of config_info_beta
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_info_tag
-- ----------------------------
DROP TABLE IF EXISTS `config_info_tag`;
CREATE TABLE `config_info_tag` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
  `tag_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'source user',
  `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='config_info_tag';

-- ----------------------------
-- Records of config_info_tag
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_tags_relation
-- ----------------------------
DROP TABLE IF EXISTS `config_tags_relation`;
CREATE TABLE `config_tags_relation` (
  `id` bigint NOT NULL COMMENT 'id',
  `tag_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
  `tag_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'tag_type',
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
  `nid` bigint NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`nid`) USING BTREE,
  UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`) USING BTREE,
  KEY `idx_tenant_id` (`tenant_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='config_tag_relation';

-- ----------------------------
-- Records of config_tags_relation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for group_capacity
-- ----------------------------
DROP TABLE IF EXISTS `group_capacity`;
CREATE TABLE `group_capacity` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
  `quota` int unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
  `usage` int unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
  `max_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数，，0表示使用默认值',
  `max_aggr_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_group_id` (`group_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='集群、各Group容量信息表';

-- ----------------------------
-- Records of group_capacity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for his_config_info
-- ----------------------------
DROP TABLE IF EXISTS `his_config_info`;
CREATE TABLE `his_config_info` (
  `id` bigint unsigned NOT NULL,
  `nid` bigint unsigned NOT NULL AUTO_INCREMENT,
  `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `src_user` text CHARACTER SET utf8 COLLATE utf8_bin,
  `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`nid`) USING BTREE,
  KEY `idx_gmt_create` (`gmt_create`) USING BTREE,
  KEY `idx_gmt_modified` (`gmt_modified`) USING BTREE,
  KEY `idx_did` (`data_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='多租户改造';

-- ----------------------------
-- Records of his_config_info
-- ----------------------------
BEGIN;
INSERT INTO `his_config_info` VALUES (0, 1, 'kwshare-file-dev.yml', 'DEFAULT_GROUP', '', 'spring:\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:9100\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n  endpoint:\r\n    health:\r\n      show-details: ALWAYS', '4282c7243095524e43fa5de666f904be', '2021-12-18 13:03:02', '2021-12-18 05:03:02', NULL, '192.168.146.1', 'I', '');
INSERT INTO `his_config_info` VALUES (0, 2, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\r\n  cloud:\r\n    gateway:\r\n      routes:\r\n      - id: kwshare-system\r\n        uri: lb://kwshare-system\r\n        predicates:\r\n          - Path=/system/**\r\n        filters:\r\n          - StripPrefix=1\r\n      - id: kwshare-file\r\n        uri: lb://kwshare-file\r\n        predicates:\r\n          - Path=/file/**\r\n        filters:\r\n          - StripPrefix=1\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:9100\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n  endpoint:\r\n    health:\r\n      show-details: ALWAYS', 'a8ef87de397bb6cfd490709abba8a345', '2021-12-18 13:03:38', '2021-12-18 05:03:38', NULL, '192.168.146.1', 'I', '');
INSERT INTO `his_config_info` VALUES (0, 3, 'kwshare-monitor-dev.yml', 'DEFAULT_GROUP', '', 'a: i', '65b941df97e8f754cbe351aa6526c49e', '2021-12-18 13:04:16', '2021-12-18 05:04:17', NULL, '192.168.146.1', 'I', '');
INSERT INTO `his_config_info` VALUES (0, 4, 'kwshare-system-dev.yml', 'DEFAULT_GROUP', '', 'spring:\r\n  boot:\r\n    admin: \r\n      client: \r\n        url: http://localhost:9100\r\n      \r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n  endpoint:\r\n    health:\r\n      show-details: ALWAYS', '2e43f1613439969264216ff890db2d01', '2021-12-18 13:04:45', '2021-12-18 05:04:46', NULL, '192.168.146.1', 'I', '');
INSERT INTO `his_config_info` VALUES (2, 5, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\r\n  cloud:\r\n    gateway:\r\n      routes:\r\n      - id: kwshare-system\r\n        uri: lb://kwshare-system\r\n        predicates:\r\n          - Path=/system/**\r\n        filters:\r\n          - StripPrefix=1\r\n      - id: kwshare-file\r\n        uri: lb://kwshare-file\r\n        predicates:\r\n          - Path=/file/**\r\n        filters:\r\n          - StripPrefix=1\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:9100\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n  endpoint:\r\n    health:\r\n      show-details: ALWAYS', 'a8ef87de397bb6cfd490709abba8a345', '2021-12-18 15:05:02', '2021-12-18 07:05:02', 'nacos', '192.168.146.1', 'U', '');
INSERT INTO `his_config_info` VALUES (2, 6, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n  boot:\n    admin:\n      client:\n        url: http://localhost:9100\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n  endpoint:\n    health:\n      show-details: ALWAYS\nsecurity: \n  ignore:\n    whites: \n    - /file/**', 'e159e156e1a763f8caa6c322d0a1297a', '2021-12-18 15:05:55', '2021-12-18 07:05:55', 'nacos', '192.168.146.1', 'U', '');
INSERT INTO `his_config_info` VALUES (3, 7, 'kwshare-monitor-dev.yml', 'DEFAULT_GROUP', '', 'a: i', '65b941df97e8f754cbe351aa6526c49e', '2021-12-18 15:13:41', '2021-12-18 07:13:42', 'nacos', '192.168.146.1', 'U', '');
INSERT INTO `his_config_info` VALUES (3, 8, 'kwshare-monitor-dev.yml', 'DEFAULT_GROUP', '', 'spring: \n  security:\n    user:\n      name: yangjing\n      password: 123456\n  boot:\n    admin:\n      ui:\n        title: 知优享服务状态监控', '0a902c55406059b096ed9ea643b35ad4', '2021-12-18 15:14:53', '2021-12-18 07:14:53', 'nacos', '192.168.146.1', 'U', '');
INSERT INTO `his_config_info` VALUES (3, 9, 'kwshare-monitor-dev.yml', 'DEFAULT_GROUP', '', 'spring: \n  security:\n    user:\n      name: yangjing\n      password: 123456\n  boot:\n    admin:\n      ui:\n        title: 知优享服务状态监控', '0a902c55406059b096ed9ea643b35ad4', '2021-12-18 15:50:00', '2021-12-18 07:50:01', 'nacos', '192.168.146.1', 'U', '');
INSERT INTO `his_config_info` VALUES (3, 10, 'kwshare-monitor-dev.yml', 'DEFAULT_GROUP', '', 'a: i', '65b941df97e8f754cbe351aa6526c49e', '2021-12-18 15:57:11', '2021-12-18 07:57:11', 'nacos', '192.168.146.1', 'U', '');
INSERT INTO `his_config_info` VALUES (1, 11, 'kwshare-file-dev.yml', 'DEFAULT_GROUP', '', 'spring:\r\n  boot:\r\n    admin:\r\n      client:\r\n        url: http://localhost:9100\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n  endpoint:\r\n    health:\r\n      show-details: ALWAYS', '4282c7243095524e43fa5de666f904be', '2021-12-18 16:29:37', '2021-12-18 08:29:38', 'nacos', '192.168.146.1', 'U', '');
INSERT INTO `his_config_info` VALUES (3, 12, 'kwshare-monitor-dev.yml', 'DEFAULT_GROUP', '', '# spring\nspring: \n  security:\n    user:\n      name: yangjing\n      password: 123456\n  boot:\n    admin:\n      ui:\n        title: 知优享服务状态监控', '7211037963206978c93a47ce0bc00f34', '2021-12-18 19:48:26', '2021-12-18 11:48:26', 'nacos', '192.168.146.1', 'U', '');
INSERT INTO `his_config_info` VALUES (3, 13, 'kwshare-monitor-dev.yml', 'DEFAULT_GROUP', '', 'spring: \n  security:\n    user:\n      name: yangjing\n      password: 123456\n  boot:\n    admin:\n      ui:\n        title: 知优享服务状态监控', '0a902c55406059b096ed9ea643b35ad4', '2021-12-18 19:51:04', '2021-12-18 11:51:04', 'nacos', '192.168.146.1', 'U', '');
INSERT INTO `his_config_info` VALUES (3, 14, 'kwshare-monitor-dev.yml', 'DEFAULT_GROUP', '', '#spring\nspring: \n  security:\n    user:\n      name: yangjing\n      password: 123456\n  boot:\n    admin:\n      ui:\n        title: 知优享服务状态监控', 'b66bbbab30dc701804212a5883389a0b', '2021-12-18 20:01:05', '2021-12-18 12:01:06', NULL, '192.168.146.1', 'D', '');
INSERT INTO `his_config_info` VALUES (0, 15, 'kwshare-monitor-dev.yml', 'DEFAULT_GROUP', '', '#spring\r\nspring: \r\n  security:\r\n    user:\r\n      name: yangjing\r\n      password: 123456\r\n  boot:\r\n    admin:\r\n      ui:\r\n        title: 知优享服务状态监控', 'd598dcac14c146f95b91cee2b427ef06', '2021-12-18 20:01:23', '2021-12-18 12:01:24', NULL, '192.168.146.1', 'I', '');
INSERT INTO `his_config_info` VALUES (14, 16, 'kwshare-monitor-dev.yml', 'DEFAULT_GROUP', '', '#spring\r\nspring: \r\n  security:\r\n    user:\r\n      name: yangjing\r\n      password: 123456\r\n  boot:\r\n    admin:\r\n      ui:\r\n        title: 知优享服务状态监控', 'd598dcac14c146f95b91cee2b427ef06', '2021-12-18 20:02:08', '2021-12-18 12:02:09', 'nacos', '192.168.146.1', 'U', '');
INSERT INTO `his_config_info` VALUES (0, 17, 'kwshare-user-dev.yml', 'DEFAULT_GROUP', '', 'spring:\r\n  datasource:\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    username: root\r\n    password: 123456\r\n    url: jdbc:mysql://localhost:3306/kwshare-user?useUnicode=true&characterEncoding=utf8', 'c43575d9a1f9db7a0b592c49a0cc7fe9', '2021-12-19 16:23:55', '2021-12-19 08:23:56', NULL, '192.168.146.1', 'I', '');
INSERT INTO `his_config_info` VALUES (2, 18, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n  boot:\n    admin:\n      client:\n        url: http://localhost:9100\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n  endpoint:\n    health:\n      show-details: ALWAYS\nsecurity: \n  ignore:\n    whites: \n    - /file/**', 'e159e156e1a763f8caa6c322d0a1297a', '2021-12-22 20:29:08', '2021-12-22 12:29:08', 'nacos', '192.168.10.3', 'U', '');
INSERT INTO `his_config_info` VALUES (2, 19, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-auth\n        uri: lb://kwshare-auth\n        predicates:\n          - Path=/auth/**\n        filters:\n          - StripPrefix=1\n  boot:\n    admin:\n      client:\n        url: http://localhost:9100\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n  endpoint:\n    health:\n      show-details: ALWAYS\nsecurity: \n  ignore:\n    whites: \n    - /file/**', 'e7d66d5281890cf1b08c80508db71dba', '2021-12-22 20:30:09', '2021-12-22 12:30:10', 'nacos', '192.168.10.3', 'U', '');
INSERT INTO `his_config_info` VALUES (2, 20, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-auth\n        uri: lb://kwshare-auth\n        predicates:\n          - Path=/auth/**\n        filters:\n          - StripPrefix=1\n  boot:\n    admin:\n      client:\n        url: http://localhost:9100\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n  endpoint:\n    health:\n      show-details: ALWAYS\nsecurity: \n  ignore:\n    whites: \n    - /auth/login', 'ac6b56df6a01797e621fc78874abc001', '2021-12-22 22:07:25', '2021-12-22 14:07:26', 'nacos', '192.168.10.3', 'U', '');
INSERT INTO `his_config_info` VALUES (2, 21, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-auth\n        uri: lb://kwshare-auth\n        predicates:\n          - Path=/auth/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-user\n        uri: lb://kwshare-user\n        predicates:\n          - Path=/user/**\n        filters:\n          - StripPrefix=1\n  boot:\n    admin:\n      client:\n        url: http://localhost:9100\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n  endpoint:\n    health:\n      show-details: ALWAYS\nsecurity: \n  ignore:\n    whites: \n    - /auth/login', 'c3d66e7d6076d247668307c1a3bee942', '2021-12-23 19:38:42', '2021-12-23 11:38:42', 'nacos', '192.168.10.3', 'U', '');
INSERT INTO `his_config_info` VALUES (15, 22, 'kwshare-user-dev.yml', 'DEFAULT_GROUP', '', 'spring:\r\n  datasource:\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    username: root\r\n    password: 123456\r\n    url: jdbc:mysql://localhost:3306/kwshare-user?useUnicode=true&characterEncoding=utf8', 'c43575d9a1f9db7a0b592c49a0cc7fe9', '2021-12-26 13:51:48', '2021-12-26 05:51:49', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (0, 23, 'kwshare-auth-dev.yml', 'DEFAULT_GROUP', '', 'a: a', 'a47864918ca9e5733d9f1c22f49afeb6', '2021-12-26 14:36:25', '2021-12-26 06:36:26', NULL, '0:0:0:0:0:0:0:1', 'I', '');
INSERT INTO `his_config_info` VALUES (20, 24, 'kwshare-auth-dev.yml', 'DEFAULT_GROUP', '', 'a: a', 'a47864918ca9e5733d9f1c22f49afeb6', '2021-12-26 14:50:17', '2021-12-26 06:50:17', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (1, 25, 'kwshare-file-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  boot:\n    admin:\n      client:\n        url: http://localhost:9100\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n  endpoint:\n    health:\n      show-details: ALWAYS\nfile:\n  path: D:\\KwShare\\', 'bab89472de0197e757e445fbc24cef8e', '2021-12-26 15:28:23', '2021-12-26 07:28:24', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (0, 26, 'application-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  boot:\n    admin:\n      client:\n        url: http://localhost:9100\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n  endpoint:\n    health:\n      show-details: ALWAYS', '61e195a4d0dd1853ca3572f08e0f4a02', '2021-12-26 15:28:34', '2021-12-26 07:28:35', NULL, '0:0:0:0:0:0:0:1', 'I', '');
INSERT INTO `his_config_info` VALUES (2, 27, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-auth\n        uri: lb://kwshare-auth\n        predicates:\n          - Path=/auth/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-user\n        uri: lb://kwshare-user\n        predicates:\n          - Path=/user/**\n  boot:\n    admin:\n      client:\n        url: http://localhost:9100\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n  endpoint:\n    health:\n      show-details: ALWAYS\nsecurity: \n  ignore:\n    whites: \n    - /auth/login', 'cd8731ae32ca3f4bedbe10add53b68eb', '2021-12-26 15:29:05', '2021-12-26 07:29:05', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (4, 28, 'kwshare-system-dev.yml', 'DEFAULT_GROUP', '', 'spring:\r\n  boot:\r\n    admin: \r\n      client: \r\n        url: http://localhost:9100\r\n      \r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: \'*\'\r\n  endpoint:\r\n    health:\r\n      show-details: ALWAYS', '2e43f1613439969264216ff890db2d01', '2021-12-26 15:29:33', '2021-12-26 07:29:34', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (20, 29, 'kwshare-auth-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  boot:\n    admin:\n      client:\n        url: http://localhost:9100\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \'*\'\n  endpoint:\n    health:\n      show-details: ALWAYS', '61e195a4d0dd1853ca3572f08e0f4a02', '2021-12-26 15:30:03', '2021-12-26 07:30:03', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (2, 30, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-auth\n        uri: lb://kwshare-auth\n        predicates:\n          - Path=/auth/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-user\n        uri: lb://kwshare-user\n        predicates:\n          - Path=/user/**\nsecurity: \n  ignore:\n    whites: \n    - /auth/login', 'ad88122a9e0ec307ddc6a9a978afd990', '2021-12-26 18:26:24', '2021-12-26 10:26:25', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (2, 31, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-auth\n        uri: lb://kwshare-auth\n        predicates:\n          - Path=/auth/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-user\n        uri: lb://kwshare-user\n        predicates:\n          - Path=/user/**\n        filters:\n          - StripPrefix=1\nsecurity: \n  ignore:\n    whites: \n    - /auth/login', '708f0771b558afb2bd73ec7751f4e310', '2021-12-26 19:29:24', '2021-12-26 11:29:24', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (2, 32, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-auth\n        uri: lb://kwshare-auth\n        predicates:\n          - Path=/auth/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-user\n        uri: lb://kwshare-user\n        predicates:\n          - Path=/user/**\n        filters:\n          - StripPrefix=1\nsecurity: \n  ignore:\n    whites: \n    - /auth/login', '708f0771b558afb2bd73ec7751f4e310', '2021-12-26 19:29:48', '2021-12-26 11:29:48', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (2, 33, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-auth\n        uri: lb://kwshare-auth\n        predicates:\n          - Path=/auth/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-user\n        uri: lb://kwshare-user\n        predicates:\n          - Path=/user/**\n        filters:\n          - StripPrefix=1\nsecurity: \n  ignore:\n    whites: \n    - /auth/login\n    - /auth/**', '26619dd1a082ac41389699de26d8be46', '2021-12-30 21:31:08', '2021-12-30 13:31:08', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (2, 34, 'kwshare-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n      - id: kwshare-system\n        uri: lb://kwshare-system\n        predicates:\n          - Path=/system/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-file\n        uri: lb://kwshare-file\n        predicates:\n          - Path=/file/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-auth\n        uri: lb://kwshare-auth\n        predicates:\n          - Path=/auth/**\n        filters:\n          - StripPrefix=1\n      - id: kwshare-user\n        uri: lb://kwshare-user\n        predicates:\n          - Path=/user/**\n        filters:\n          - StripPrefix=1\nsecurity: \n  ignore:\n    whites: \n    - /auth/login', '708f0771b558afb2bd73ec7751f4e310', '2021-12-30 22:07:35', '2021-12-30 14:07:35', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (15, 35, 'kwshare-user-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: 12345678\n    url: jdbc:mysql://localhost:3306/kwshare-user?useUnicode=true&characterEncoding=utf8', '4258623803aed6da5eb37570aaa0ea62', '2021-12-31 22:00:08', '2021-12-31 14:00:08', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (15, 36, 'kwshare-user-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: 12345678\n    url: jdbc:mysql://localhost:3306/kwshare-user?useUnicode=true&characterEncoding=utf8\nmybatis-plus:\n  configuration:\n    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl', '36c1d7b1487599784d04f62ab8fbc70d', '2021-12-31 22:02:25', '2021-12-31 14:02:26', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (15, 37, 'kwshare-user-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: 12345678\n    url: jdbc:mysql://localhost:3306/kwshare-user?useUnicode=true&characterEncoding=utf8\n\nlogging:\n  level:\n    com:\n      lawt:\n        repository:\n          mapper: debug', 'f864300f69c17acc52c55167aacf8d47', '2021-12-31 22:03:45', '2021-12-31 14:03:46', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (15, 38, 'kwshare-user-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: 12345678\n    url: jdbc:mysql://localhost:3306/kwshare-user?useUnicode=true&characterEncoding=utf8', '4258623803aed6da5eb37570aaa0ea62', '2021-12-31 22:04:31', '2021-12-31 14:04:31', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (15, 39, 'kwshare-user-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: 12345678\n    url: jdbc:mysql://localhost:3306/kwshare-user?useUnicode=true&characterEncoding=utf8\nmybatis-plus:\n  configuration:\n    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl', '36c1d7b1487599784d04f62ab8fbc70d', '2021-12-31 23:24:11', '2021-12-31 15:24:12', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
INSERT INTO `his_config_info` VALUES (4, 40, 'kwshare-system-dev.yml', 'DEFAULT_GROUP', '', 'a: a', 'a47864918ca9e5733d9f1c22f49afeb6', '2022-01-08 17:19:32', '2022-01-08 09:19:32', 'nacos', '0:0:0:0:0:0:0:1', 'U', '');
COMMIT;

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
  `role` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `resource` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `action` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  UNIQUE KEY `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `role` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  UNIQUE KEY `idx_user_role` (`username`,`role`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of roles
-- ----------------------------
BEGIN;
INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');
COMMIT;

-- ----------------------------
-- Table structure for tenant_capacity
-- ----------------------------
DROP TABLE IF EXISTS `tenant_capacity`;
CREATE TABLE `tenant_capacity` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
  `quota` int unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
  `usage` int unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
  `max_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数',
  `max_aggr_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_tenant_id` (`tenant_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='租户容量信息表';

-- ----------------------------
-- Records of tenant_capacity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tenant_info
-- ----------------------------
DROP TABLE IF EXISTS `tenant_info`;
CREATE TABLE `tenant_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `kp` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'kp',
  `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
  `tenant_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_name',
  `tenant_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'tenant_desc',
  `create_source` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'create_source',
  `gmt_create` bigint NOT NULL COMMENT '创建时间',
  `gmt_modified` bigint NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`) USING BTREE,
  KEY `idx_tenant_id` (`tenant_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='tenant_info';

-- ----------------------------
-- Records of tenant_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`username`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
